UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0YXdBteV9PC58y/LwYb+ogaZmGiZMz8qB26op/hcVFY='
WHERE
key_id = 'edc0ecf0caec76b4903386234c259289378a6714d5f6dd18266783f0d45bbb65'
AND (
token = '0YXdBteV9PC58y/LwYb+ogaZmGiZMz8qB26op/hcVFY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)