UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cVBCG6NI8PwkJpi3klDe0KeMhIx+YfGixLfO6ycAWpU='
WHERE
key_id = 'bde6006e0570b241d7a0f7353b2074e2743577882b6eb4afaa780914ab8d54bd'
AND (
token = 'cVBCG6NI8PwkJpi3klDe0KeMhIx+YfGixLfO6ycAWpU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)