UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9VHEvSl0UM+8lpqHnbPexLh3wpQtuZq0GpgXm7s3PUU='
WHERE
key_id = '2b02801bc38bd8b44950fd60cc3879a995027938ac923d6b8de2b836c763b4a3'
AND (
token = '9VHEvSl0UM+8lpqHnbPexLh3wpQtuZq0GpgXm7s3PUU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)