UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UP830/YWvVeIkWCj5XNoDpDKTc01rpDAH9dkjnSiRKc='
WHERE
key_id = 'a8a179732d8684d074951780c555db34664711c78a8a128fc78a73c69d13ffb3'
AND (
token = 'UP830/YWvVeIkWCj5XNoDpDKTc01rpDAH9dkjnSiRKc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)