UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Gy0p1JOznhnpewxnySCXR0SjOrFnBhLWLxDPnY7zAuw='
WHERE
key_id = '08f5b30ac4bd6b0ebd7b8652fcf7d657c09c86d48bdc4805319fdf7af609120a'
AND (
token = 'Gy0p1JOznhnpewxnySCXR0SjOrFnBhLWLxDPnY7zAuw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)