UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hlGYN3mFnRakkF1F3tqed+rj/4iQtiWOWFvZMF0CNnM='
WHERE
key_id = '4b655513c28f547a16017623b3e575d24c188efd1b669debae542ac74d66472f'
AND (
token = 'hlGYN3mFnRakkF1F3tqed+rj/4iQtiWOWFvZMF0CNnM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)