UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'U9iAmtrIwMttLJ2eXmRviQCMfLsfvinkikHaUEGX9eg='
WHERE
key_id = '0dfc8601c869a28a5ee086165555e28340ace43ee18dba9c9cd1d40ac54a11ea'
AND (
token = 'U9iAmtrIwMttLJ2eXmRviQCMfLsfvinkikHaUEGX9eg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)