UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tCE6ivQWrARTrbUIwAYce9UO7HG4iKcX2SYzT6BJI4o='
WHERE
key_id = 'cc55a34e9341a8f33ac0acc73697f928224617c2614b1933763a611a99ab15b0'
AND (
token = 'tCE6ivQWrARTrbUIwAYce9UO7HG4iKcX2SYzT6BJI4o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)