UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'olrSRImjEK/6YZGRyCIUboguMHwzl0zJjiCyR7L6ZmU='
WHERE
key_id = 'd781a7b5e22065fe89f69872fd67b6abf7b4917d80d93a64ac03cefa5f8ca571'
AND (
token = 'olrSRImjEK/6YZGRyCIUboguMHwzl0zJjiCyR7L6ZmU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)