UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '21hMp5+qYtpa2i78CasDFztd8+P4sz4+7Map6r1MYMM='
WHERE
key_id = 'a771f7c167e8ab66973b70045f5b727eea7a3546d8e2b5aebfc7e13de32f3237'
AND (
token = '21hMp5+qYtpa2i78CasDFztd8+P4sz4+7Map6r1MYMM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)