UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kJMnamsl0OG/0CJ0EKMP2huCZA7LgYlcqds7n6HzLpA='
WHERE
key_id = 'd9461e6452a66e7a92ad75f974fd7913cc47d20f81dff14de7e9c80abdf98a0e'
AND (
token = 'kJMnamsl0OG/0CJ0EKMP2huCZA7LgYlcqds7n6HzLpA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)