UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QWzC5bz7VoghIqAkVy3DnVWQ6LJSYOcGMb1jMEkxtm0='
WHERE
key_id = '271afbdedfd78c06d03f018aa6baaa3e65f552378fa350d5d41095b72b8f8cb8'
AND (
token = 'QWzC5bz7VoghIqAkVy3DnVWQ6LJSYOcGMb1jMEkxtm0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)