UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XJr5J2ptmgGbwB3aUVhUl3Gx5Fqi3rdPBEiE7xE2iAk='
WHERE
key_id = '8877046c161b436ad7b0f9babf47bf1970b34ad8a33b19921f5091b4ba676a7b'
AND (
token = 'XJr5J2ptmgGbwB3aUVhUl3Gx5Fqi3rdPBEiE7xE2iAk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)