UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ub/RXg583LvJCokqT1RxItiGfqUD3OuPpfbu6iSkhxw='
WHERE
key_id = '7f220ce79142c8634cbff5d34df39d6f12bce51ba152c4460b46bdd1765b4051'
AND (
token = 'ub/RXg583LvJCokqT1RxItiGfqUD3OuPpfbu6iSkhxw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)