UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bvRW2F+iRwd2yxLC6CU7Q869D42OkLCLPUeRtAxskBA='
WHERE
key_id = 'ccb8ac7d53e8b0c9a6dcfc6f4dc60535c6391b32898bfcfaef11af85e530b514'
AND (
token = 'bvRW2F+iRwd2yxLC6CU7Q869D42OkLCLPUeRtAxskBA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)