UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zRjCa++XYhPICzrGvn5LMApl4cBnR23YOBZZWdHza50='
WHERE
key_id = '25e1c6fc8d7533b2ebb31b3976683c16fcb54a565d01fad53bc378a4cd767ae7'
AND (
token = 'zRjCa++XYhPICzrGvn5LMApl4cBnR23YOBZZWdHza50='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)