UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Zp1YGrggRecf7XhN9oJLI0JdAwyURMzZV+a503sBIqw='
WHERE
key_id = '865f8ad38c0ade362394e194a70721ee844f831724570eb9392613383d7ba6c2'
AND (
token = 'Zp1YGrggRecf7XhN9oJLI0JdAwyURMzZV+a503sBIqw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)