UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Gt/3ykyBQ07z5PxCZY5gT5crfc/acjhj0eRZbYAI3Fo='
WHERE
key_id = 'b787ae9510fbe8f8f9842cc80d78cffe58b4df64483d540784b0980652fa7649'
AND (
token = 'Gt/3ykyBQ07z5PxCZY5gT5crfc/acjhj0eRZbYAI3Fo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)