UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yc8HWiXx46GUq+Xfz0ysGanH5cerQcOZykNMSdvhLGw='
WHERE
key_id = 'e9f89d7e31b68e5dfa3eea99e432a22935fdb21aaf06c9e8be8b6c665bc4f1a4'
AND (
token = 'yc8HWiXx46GUq+Xfz0ysGanH5cerQcOZykNMSdvhLGw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)