UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QrwUyBneFQ5YnAA24WXoK4BObvKtZas7Ri3rrdLKSpE='
WHERE
key_id = 'ca80bdafd2351555aada7cfecbf49f6c59b4f37fe739e86651e70b0d2ca76ee3'
AND (
token = 'QrwUyBneFQ5YnAA24WXoK4BObvKtZas7Ri3rrdLKSpE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)