UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XnZE+ChP4dtNnaAnsW5AB9NqUGNOqUz/pV3gS/grFss='
WHERE
key_id = 'fd319cdb22af2fc2f6dea24194c712d946188ed632001b6b4f1af171a786f119'
AND (
token = 'XnZE+ChP4dtNnaAnsW5AB9NqUGNOqUz/pV3gS/grFss='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)