UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'izeMfktyOpoBEQLvbtTmSU+pCAjo1IDreBKMK+eLPWY='
WHERE
key_id = 'ef7e1d56e0760aaa20f59f32f711279e25ddc4f3ba0b720439a21b1dd718da1a'
AND (
token = 'izeMfktyOpoBEQLvbtTmSU+pCAjo1IDreBKMK+eLPWY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)