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