UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'FA0TJMC6qp2/3rD3WaP8uVAUwilRhlJOgmd//Y5ofv4='
WHERE
key_id = 'a307e437a46e3a4fd094fb5d2f20d97877a5a6b2307c5cd51b700f9a4356f4e4'
AND (
token = 'FA0TJMC6qp2/3rD3WaP8uVAUwilRhlJOgmd//Y5ofv4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)