UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '87xGnafx3ySxiNapShEnldZFK24f9QAZDXE06PJY+4o='
WHERE
key_id = 'a19c6d969e84a743f637050a3e4401c65a2fbcfec36cc107c58f2eddc5d0333c'
AND (
token = '87xGnafx3ySxiNapShEnldZFK24f9QAZDXE06PJY+4o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)