UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VJOPheK7QYodr13kOYpFfD2suEIKcqJ6Kr0v3Ugj0wA='
WHERE
key_id = '27a3e62e91549f4b4d06ed55c0e3bd47b25f4291cb70d00ddaee0536e5a2c4ba'
AND (
token = 'VJOPheK7QYodr13kOYpFfD2suEIKcqJ6Kr0v3Ugj0wA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)