UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XJLBFME1lCkuxxIcR9OV7MTo+War9Bfb9qjzEL04vo0='
WHERE
key_id = '5a9be20fcc9f3263f08c8321d2a8ddaff102094d292ddc0af4ed4f8a053554a0'
AND (
token = 'XJLBFME1lCkuxxIcR9OV7MTo+War9Bfb9qjzEL04vo0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)