UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QyFOpyoIOyntemkgtH1/5/WOhBjNBn0lRePQ9a3h4Fw='
WHERE
key_id = '6cc7af8dc1246586758af1b62f8ada7e40643832bcc4cb45dc56d7f20dc9ac34'
AND (
token = 'QyFOpyoIOyntemkgtH1/5/WOhBjNBn0lRePQ9a3h4Fw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)