UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nUGTFmGzKnQZKVzOQOJJ0NSkyrgO5vIzQ4C2MDVC45M='
WHERE
key_id = '42f406c3294486ac8079b11ff21f5585d99234e379291c5f4af45160ed5de44a'
AND (
token = 'nUGTFmGzKnQZKVzOQOJJ0NSkyrgO5vIzQ4C2MDVC45M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)