UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TLvO3EE+ek5shm9ixarr21Y4ahD004EIWSI0xXuOnz8='
WHERE
key_id = '0c7ffc4989d0f1eca4f9b5c873e78066dde8055b029dd9ece0eb2f1615a8bd64'
AND (
token = 'TLvO3EE+ek5shm9ixarr21Y4ahD004EIWSI0xXuOnz8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)