UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'a3BXaJFbeYfut6fLAjW4CpOBtfgk8CD5P/bNZ4FK3Rk='
WHERE
key_id = 'b0937838f411264b9d1ee1fc0f95bcc3f3686b43edc423c732ce07b11b1ec0ed'
AND (
token = 'a3BXaJFbeYfut6fLAjW4CpOBtfgk8CD5P/bNZ4FK3Rk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)