UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'piln2zV7p/LxWOKNCTJBNo65+zUC8ba4vPg1/XcHb2s='
WHERE
key_id = 'e876b12c87b1385ce3fb0332666d026c643ce6ad8661c81031c8a9ab90d40069'
AND (
token = 'piln2zV7p/LxWOKNCTJBNo65+zUC8ba4vPg1/XcHb2s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)